Toggle Sphinx Query
SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Road to Ruin"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?
+
+

Keyword

?
New Search
83 results for: Title - The Road to Ruin

1
18 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Blue Beard

2
20 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Highland Reel

3
21 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Poor Soldier

4
23 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Positive Man

5
25 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

6
27 February 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Farmer

7
01 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

8
03 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

9
05 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: A Divertisement

10
08 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

11
10 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Romp

12
12 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125

13
13 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Orpheus and Eurydice

14
15 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

15
17 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Poor Soldier

16
19 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125

17
20 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

18
22 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Maid of the Oaks

Dance: In I afterpiece: a Dance-

19
24 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

20
27 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

21
29 March 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

22
09 April 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125

23
11 April 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Robin Hood

24
13 April 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

25
16 April 1792 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125